﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using Texfina.Core.Data;

namespace Texfina.DOQry.Co
{
    public class DFamilia
    {

        public static IDataReader Familia_qry01(int psintypesel)
        {
            DBAccess db = new DBAccess();
            db.AddParameter("@psintypesel", psintypesel);
            return db.ExecuteReader("MG_Familias_qry01");
        }


        public static IDataReader Familia_qry02(int psintypesel, string pchr_idgrupo)
        {
            DBAccess db = new DBAccess();
            db.AddParameter("@psintypesel", psintypesel);
            db.AddParameter("@pchr_idgrupo", pchr_idgrupo);
            return db.ExecuteReader("MG_Familias_qry01");
        }

        public static IDataReader Familia_qry03(int psintypesel, string pchr_idgrupo, string pchr_idfamilia)
        {
            DBAccess db = new DBAccess();
            db.AddParameter("@psintypesel", psintypesel);
            db.AddParameter("@pchr_idgrupo", pchr_idgrupo);
            db.AddParameter("@pchr_idfamilia", pchr_idfamilia);
            return db.ExecuteReader("MG_Familias_qry01");
        }
    }
}
